<template>
  <div>
    <div class="gva-search-box">
      <el-form :inline="true" :model="searchInfo" class="demo-form-inline" @keyup.enter="onSubmit">
        <el-form-item label="创建时间">
          <el-date-picker v-model="searchInfo.startCreatedAt" type="datetime" placeholder="开始时间" />
          —
          <el-date-picker v-model="searchInfo.endCreatedAt" type="datetime" placeholder="结束时间" />
        </el-form-item>
        <el-form-item>
          <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
          <el-button icon="refresh" @click="onReset">重置</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="gva-table-box">
      <el-table
        ref="multipleTable"
        style="width: 100%"
        tooltip-effect="dark"
        :data="tableData"
        row-key="ID"
        size="small"
        border
        :cell-style="{padding:'0px'}"
        :header-cell-style="{background:'#a3c6d2',color:'#849ba1',padding:'0px'}"
        @selection-change="handleSelectionChange"
      >
        <el-table-column align="left" label="源数据类型" prop="srcDataType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据库类型" prop="srcDbType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源Schema" prop="srcSchemaName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源表名" prop="srcTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="标识码" prop="bsm" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源表注释" prop="tbComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods表名称" prop="odsTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods表注释" prop="odsTbComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods表标签" prop="odsTbLabel" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="表数据分类" prop="odsTbCategory" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="备注" prop="remarks" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="操作" width="150px">
          <template #default="scope">
            <el-button type="primary" link icon="edit" class="table-button" @click="updateOdsDbTableFunc(scope.row)">变 更</el-button>
            <el-button type="primary" link icon="delete" @click="deleteRow(scope.row)">删除</el-button>
          </template>
        </el-table-column>
      </el-table>
      <div class="gva-pagination">
        <el-pagination
          layout="total, sizes, prev, pager, next, jumper"
          :current-page="page"
          :page-size="pageSize"
          :page-sizes="[10, 30, 50, 100]"
          :total="total"
          @current-change="handleCurrentChange"
          @size-change="handleSizeChange"
        />
      </div>
    </div>
    <el-dialog v-model="dialogFormVisible" :before-close="closeDialog" title="修改源数据库表" class="dialog-mid">
      <el-form
        ref="elFormRef"
        class="x-form"
        :model="formData"
        label-position="right"
        :rules="rule"
        :inline="true"
      >
        <el-form-item label="源数据类型:" prop="dbType">
          <el-input v-model="formData.dbType" disabled />
        </el-form-item>
        <el-form-item label="源数据库id:" prop="srcDbId">
          <el-input v-model="formData.srcDbId" disabled />
        </el-form-item>
        <el-form-item label="源Schema:" prop="srcSchemaName">
          <el-input v-model="formData.srcSchemaName" disabled />
        </el-form-item>
        <el-form-item label="源表名:" prop="srcTbName">
          <el-input v-model="formData.srcTbName" disabled />
        </el-form-item>
        <el-form-item label="标识码:" prop="bsm">
          <el-input v-model="formData.bsm" disabled />
        </el-form-item>
        <el-form-item label="源表注释:" prop="tbComment">
          <el-input v-model="formData.tbComment" disabled />
        </el-form-item>
        <el-form-item label="ods库名:" prop="odsSchemaName">
          <el-select v-model="formData.odsSchemaName">
            <el-option v-for="item in odsDbSchemaList" :key="item.id" :value="item.label" :label="item.label" />
          </el-select>
        </el-form-item>
        <el-form-item label="ods表名称:" prop="odsTbName">
          <el-input v-model="formData.odsTbName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods表注释:" prop="odsTbComment">
          <el-input v-model="formData.odsTbComment" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods表标签:" prop="odsTbLabel">
          <el-input v-model="formData.odsTbLabel" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="表数据分类:" prop="odsTbCategory">
          <el-input v-model="formData.odsTbCategory" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="备注:" prop="remarks">
          <el-input v-model="formData.remarks" placeholder="请输入" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button @click="closeDialog">取 消</el-button>
          <el-button type="primary" @click="enterDialog">确 定</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script>
export default {
  name: 'OdsDbTable'
}
</script>

<script setup>
import {
  createOdsDbTable,
  deleteOdsDbTable,
  updateOdsDbTable,
  findOdsDbTable,
  getOdsDbTableList
} from '@/api/odsDbTable'

import { ElMessage, ElMessageBox } from 'element-plus'
import { ref, reactive } from 'vue'
import { getDict } from '@/utils/dictionary'

const formData = ref({})

const rule = reactive({
  odsSchemaName: [
    {
      required: true,
      message: '表数据分类必填',
      trigger: 'blur'
    }
  ],
  odsTbName: [
    {
      required: true,
      message: '表数据分类必填',
      trigger: 'blur'
    }
  ],
})

const elFormRef = ref()

const page = ref(1)
const total = ref(0)
const pageSize = ref(10)
const tableData = ref([])
const searchInfo = ref({})

const onReset = () => {
  searchInfo.value = {}
  getTableData()
}

const onSubmit = () => {
  page.value = 1
  pageSize.value = 10
  getTableData()
}

const handleSizeChange = (val) => {
  pageSize.value = val
  getTableData()
}

const handleCurrentChange = (val) => {
  page.value = val
  getTableData()
}

const getTableData = async() => {
  const table = await getOdsDbTableList({ page: page.value, pageSize: pageSize.value, ...searchInfo.value })
  if (table.code === 0) {
    tableData.value = table.data.list
    total.value = table.data.total
    page.value = table.data.page
    pageSize.value = table.data.pageSize
  }
}

getTableData()


const setOptions = async() => {
}

setOptions()

const multipleSelection = ref([])
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

const deleteRow = (row) => {
  ElMessageBox.confirm('确定要删除吗?', '提示', {
    confirmButtonText: '确定',
    cancelButtonText: '取消',
    type: 'warning'
  }).then(() => {
    deleteOdsDbTableFunc(row)
  })
}



const type = ref('')

const updateOdsDbTableFunc = async(row) => {
  const res = await findOdsDbTable({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    formData.value = res.data.reodsDbTable
    dialogFormVisible.value = true
  }
}

const deleteOdsDbTableFunc = async(row) => {
  const res = await deleteOdsDbTable({ ID: row.ID })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === 1 && page.value > 1) {
      page.value--
    }
    getTableData()
  }
}

const dialogFormVisible = ref(false)

const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {}
}
const enterDialog = async() => {
  elFormRef.value?.validate(async(valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createOdsDbTable(formData.value)
        break
      case 'update':
        res = await updateOdsDbTable(formData.value)
        break
      default:
        res = await createOdsDbTable(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      await getTableData()
    }
  })
}
const odsDbSchemaList = ref([])
const getDictConfig = async() => {
  odsDbSchemaList.value = await getDict('odsSchemaList')
}

getDictConfig()

</script>

<style>
</style>
